php "select from table" question - GoFuckYourself.com

alex79 · 11-24-2004, 03:00 AM

i want to select the distincts rows from a table after the "keyword1 keyword2 keyword3" phrase

first will be displayed the results that contain the exact phrase "keyword1 keyword2 keyword3" and after that the rows that contain at least one of the kweyword

the displayed rows must be distnict, the rows that contain the exact phrase "keyword1 keyword2 keyword3" must be displayed first

how can i do this select phrase?

thanks

nnweb · 11-24-2004, 10:05 AM

umm I don't really understand the question or your table structure but you can try ORDER BY or sort the results once they are selected.

fris · 11-24-2004, 10:06 AM

do you mean you are trying to perform a mysql command?

11-24-2004, 03:00 AM	#1
alex79 Confirmed User Join Date: Jun 2002 Location: france Posts: 996	php "select from table" question i want to select the distincts rows from a table after the "keyword1 keyword2 keyword3" phrase first will be displayed the results that contain the exact phrase "keyword1 keyword2 keyword3" and after that the rows that contain at least one of the kweyword the displayed rows must be distnict, the rows that contain the exact phrase "keyword1 keyword2 keyword3" must be displayed first how can i do this select phrase? thanks

11-24-2004, 10:06 AM	#3
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,359	do you mean you are trying to perform a mysql command? __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

11-24-2004, 10:05 AM	#2
nnweb Confirmed User Industry Role: Join Date: Apr 2004 Location: OC Posts: 720	umm I don't really understand the question or your table structure but you can try ORDER BY or sort the results once they are selected.