SELECT from 2 columns
Posted by: Jim Farthing
Date: September 21, 2007 10:56AM
I have what I hope is a simple question....
I have a table with several columns, the 2 I am concerned with at the moment are Category and Keywords.
I need to search both of these columns for a word or short phrase that I get from a form.
For example, the search can be 'Antiques' or 'Antique Dealers'
I tried to use this
SELECT name, address, city, phone
WHERE keywords LIKE '%$search%'
OR category LIKE '%$search%'
ORDER BY name LIMIT %d,%d"
in several different ways but no joy.
When I use that snippet of code, I will get any matches from 'keywords' but nothing from category, even though I know there is a category with the var in it....
I have also tried
WHERE CONCAT_WS(' ',keywords,category) LIKE '%$search%'
ORDER BY name LIMIT %d,%d
This gives me nothing for multiword searches....
Edited 2 time(s). Last edit at 09/21/2007 01:01PM by Jim Farthing.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.