Hi,

If I have the following statement....

SELECT * FROM table_name WHERE column_name LIKE '%B747%'

How do I not specify a column name, it must use all available columns?

WHERE * does not seem to work.

Can you please help!??

THANX!!

http://www.webmaster-forums.net/showthread.php?t=31665

Hi,

I have followed the link and read through it.

Please excuse my stupidity, but I am really not succeeding in creating or searching with fulltext indexes.

I do not even know if i am setting up the database correctly.

Will you please advise me on how to do this correctly?

The best way for use to know if you have set you database up proply and asvise you on the matter would be to tell us what fields you have done and what you have set them all at also ding this would help people show you what kind of php script you would need to do the job you after

Llama,

Typically you must know what types of data are present in each of your columns. Your WHERE condition (LIKE '%B747%') implies that you are searching on string data only. Certainly you would not want that query to go against a column with integers.

You will need to identify all the columns in your table that you want to search and then create a compound query, such as:

SELECT * from <table> WHERE
    column1 like '%B747%' OR
    column2 like '%B747%' OR
    column3 like '%B747%' OR
    column4 like '%B747%'