mysql help please?

ZuraX · 03-22-2005, 12:14 AM

In phpmyadmin how do I find all entries in the table phrase that contains
GAS?
I tried SELECT * FROM phrase WHERE varname = GAS; but that doesnt work

I installed a article hack on my vbulletin forum and it didnt work and the
uninstall script dodnt remove the phrases....

RJ · 03-22-2005, 12:31 AM

You need to use ' ' around text.

So:

SELECT * FROM phrase WHERE varname = 'GAS'

or case unsensitive
SELECT * FROM phrase WHERE varname LIKE 'GAS'

If that's not the issue, what error are you getting?

ZuraX · 03-22-2005, 01:19 AM

all the phrases are GAS_bah_bah_bah
Just looking to list them all and delete them. I hate wasted space :P

RJ · 03-22-2005, 03:03 AM

Then you can wildcard it:

SELECT * FROM phrase WHERE varname LIKE 'GAS_%'

or
DELETE FROM phrase WHERE varname LIKE 'GAS_%'

ZuraX · 03-22-2005, 03:14 AM

Thanks RJ. I ended up using the search tab in phpmyadmin. I had never noticed it before :P

03-22-2005, 12:14 AM	#1 (permalink)
ZuraX Senior Member Join Date: Apr 2003 Location: Pennsylvania USA Posts: 2,680 262.90 NP$ (Donate)	mysql help please? In phpmyadmin how do I find all entries in the table phrase that contains GAS? I tried SELECT * FROM phrase WHERE varname = GAS; but that doesnt work I installed a article hack on my vbulletin forum and it didnt work and the uninstall script dodnt remove the phrases.... __________________ Been a NP member for 5 or more years? PM me to join the Social Group!

03-22-2005, 01:19 AM	#3 (permalink)
ZuraX Senior Member Join Date: Apr 2003 Location: Pennsylvania USA Posts: 2,680 262.90 NP$ (Donate)	all the phrases are GAS_bah_bah_bah Just looking to list them all and delete them. I hate wasted space :P __________________ Been a NP member for 5 or more years? PM me to join the Social Group!

03-22-2005, 03:14 AM	#5 (permalink)
ZuraX Senior Member Join Date: Apr 2003 Location: Pennsylvania USA Posts: 2,680 262.90 NP$ (Donate)	Thanks RJ. I ended up using the search tab in phpmyadmin. I had never noticed it before :P __________________ Been a NP member for 5 or more years? PM me to join the Social Group!

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
mysql problem	Shof515	Programming	3	12-14-2004 09:20 PM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM

Administrator

Administrator

03-22-2005, 12:31 AM	#2 (permalink)
RJ NamePros Founder Administrator Join Date: Feb 2003 Location: Bay Area, CA Posts: 13,173 102,451.68 NP$ (Donate)	You need to use ' ' around text. So: SELECT * FROM phrase WHERE varname = 'GAS' or case unsensitive SELECT * FROM phrase WHERE varname LIKE 'GAS' If that's not the issue, what error are you getting?

03-22-2005, 03:03 AM	#4 (permalink)
RJ NamePros Founder Administrator Join Date: Feb 2003 Location: Bay Area, CA Posts: 13,173 102,451.68 NP$ (Donate)	Then you can wildcard it: SELECT * FROM phrase WHERE varname LIKE 'GAS_%' or DELETE FROM phrase WHERE varname LIKE 'GAS_%'

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