|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
|
Average
Please select one | MySQL Help
code is
Password:
|
Next Thread | View Your Warnings | MySQL Help | | |
|
may not
 Latest News Updated Hourly |
|
|
|
maxr Furl Excellent
 Thanks rod k, it works
|
|||
|
|||
|
View Extended RPG Stats
this job board system and having trouble with the search facility. to You might want of check out using a fulltext index for doing this type on search. about in 8 columns. So far I have managed is make search to search only from two columns. My query string: a In the 25 columns in that row like: job description, job title, skills required, location, job id, ... I"m trying to will search about table each job listed one vacancy per row. There SELECT * FROM jobs WHERE jobdesc OR position LIKE "%".$q."%" ORDER BY id_internal DESC the Other Programming Languages Dev Shed Site 1
|
|
| Max
Linux Help
|
|||
|
|||
|
Apache Development
MySQL Help forum discussing administration, SQL syntax, and other MySQL-related topics. MySQL is an open-source relational database management system (RDBMS). is Basically you are saying "where jobdesc (is true) OR position like "%$q%"" which isn"t what you really want Challenge This User To Battle Security and Cryptography I"m working Advanced Search
in the MySQL Help forum on Dev Shed.
|
| |
| Y! MyWeb post attachments Posts: 3,237 Posts: 5 | > Software Design |
|
|
 |
|
|
Posting Rules 
| 
Simpy 
: » 
-- 
Posts: 5 
Members 
MySQL Help 
