MySQL Problemo

Barrucadu · 10-07-2005, 02:32 PM

How wuld I get all the results which contain a value? eg, all the results containing the letter e?

aween · 10-07-2005, 02:48 PM

$sql = "SELECT * FROM table WHERE letter='$l'";

and then it would be

page.php?l=e

Barrucadu · 10-07-2005, 02:51 PM

no, that would get all the results equal to $l, i want it to get all the results containing $l, so eg: $l = e, hello, e, england, pie would all get shown

mholt · 10-07-2005, 03:36 PM

SELECT * FROM tablename WHERE field LIKE '%e%' LIMIT 10

Alternatively... to use a variable...

$query = mysql_query("SELECT * FROM tablename WHERE field LIKE '%".$variable."%' LIMIT 10");

You can take out the LIMIT 10 if you want.

Peter · 10-07-2005, 04:02 PM

compuXP's response is exactly what you are after.

Just a note the % wildcard matches any amount of letters including 0 there is also a wildcard which is _ this matches any single character if you wanted say for example any result that contained e but did not start with e you could combine the 2 and have SELECT * FROM tablename WHERE field LIKE '_%e%' LIMIT 10

Barrucadu · 10-08-2005, 12:55 AM

how would i only return firlds that did not contain that value? eg return field 1, 2 and 3 if they all contain the criteria and then return all the rows where field1 is not the criteria field2 is and field 3 is

Peter · 10-08-2005, 04:23 AM

if you want to find something that does not fit the criteria instead of using LIKE in the query you would use NOT LIKE

Not sure if this fully answers your question as I did not fully understand what you wanted.

10-07-2005, 02:32 PM	THREAD STARTER #1 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	MySQL Problemo How wuld I get all the results which contain a value? eg, all the results containing the letter e? __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

10-07-2005, 02:48 PM	#2 (permalink)
aween Pro Coder & Designer Join Date: Apr 2005 Location: Netherlands Posts: 967	$sql = "SELECT * FROM table WHERE letter='$l'"; and then it would be page.php?l=e __________________ aween web development

10-07-2005, 02:51 PM	THREAD STARTER #3 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	no, that would get all the results equal to $l, i want it to get all the results containing $l, so eg: $l = e, hello, e, england, pie would all get shown __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

10-08-2005, 12:55 AM	THREAD STARTER #6 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	how would i only return firlds that did not contain that value? eg return field 1, 2 and 3 if they all contain the criteria and then return all the rows where field1 is not the criteria field2 is and field 3 is __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOWTO: Install the Apache Web Server, Perl, PHP, and MySQL on Windows	deadserious	Webmaster Tutorials	96	05-27-2007 01:24 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
HOW TO: Use shell to control MySQL.	abdulmueid	Webmaster Tutorials	16	08-27-2005 08:17 AM
800MB Space, 25GB Bandwidth, Unl. MySQL DB, and more Just $4.00 a month!	resellerlogic	Web Hosting Offers	0	04-05-2005 06:44 PM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM

10-07-2005, 03:36 PM	#4 (permalink)
mholt DNOA Member Join Date: May 2004 Posts: 5,040	SELECT * FROM tablename WHERE field LIKE '%e%' LIMIT 10 Alternatively... to use a variable... $query = mysql_query("SELECT * FROM tablename WHERE field LIKE '%".$variable."%' LIMIT 10"); You can take out the LIMIT 10 if you want.

10-07-2005, 04:02 PM	#5 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,074	compuXP's response is exactly what you are after. Just a note the % wildcard matches any amount of letters including 0 there is also a wildcard which is _ this matches any single character if you wanted say for example any result that contained e but did not start with e you could combine the 2 and have SELECT * FROM tablename WHERE field LIKE '_%e%' LIMIT 10

10-08-2005, 04:23 AM	#7 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,074	if you want to find something that does not fit the criteria instead of using LIKE in the query you would use NOT LIKE Not sure if this fully answers your question as I did not fully understand what you wanted.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)