|
[QUOTE=lost&found;17182590]
SELECT * FROM Name WHERE name LIKE '%pattern%'
That works with one column like 'name' but if I wanted to query other columns like name,title,comment,ect how would I form this SQL statement?
Try this:
SELECT Name, FROM table
WHERE CONTAINS((COLUMN NAME 1, COLUMN NAME 2), '%pattern%');
__________________
Banners - Design - TGP & more
Trade: Teenies In Action
icq: 256664696
|