karaktie

ok thanks for that :) I will try what you said. I feared i would have to do it this way I will tell u if it works for me or not.

Just a specific table for instance say 'table01' So i have a database with 5 tables in, i only want it to search one whole table.

i am not the desiogner of the database, i am mearly transferring the database form an offline database fomr one company to MySQL to go with a website i am making for yet another company. Very complicated but i need a keyword search page, which searches the table for a keyword, how would that be done easily? I am not allowed to change the design of the database for some obscure reason >.<

Hello all as the title says it, i am trying to search a large database for a keyword. I understand that you can use the LIKE '% %' to search for a keyword. But it only works on one column at a time. My database has around 30 coloumns and i wish to search every single one without having to type each column out. I was wondering if there was a wildcard to use on a data to say like [code]("select id from table_name where (wildcard which selects every coloumn) LIKE '%keyword%'")[/code] Any help would be [b]GREATLY[/b] appreciated!