Welcome to HostingForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

mysql help please?

  
   Web Hosting Problem Solving Community! (Home) -> Webmaster RSS
Next:  Loosing Active Directory Users and Computers icon..  
Author Message
venomx

External


Since: Jun 13, 2004
Posts: 1064



(Msg. 1) Posted: Tue Mar 22, 2005 3:36 am
Post subject: mysql help please?
Archived from groups: alt>www>webmaster (more info?)
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....

 >> Stay informed about: mysql help please? 
Back to top
Login to vote
user94

External


Since: Sep 14, 2004
Posts: 2384



(Msg. 2) Posted: Tue Mar 22, 2005 4:35 am
Post subject: Re: mysql help please? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Viper wrote

 > 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....

If you go to the main page for your database (top link on the left) you
can then hit "search" and enter GAS in the search box.

You can select which tables to search. If you select them all, it will
search every field on every table.

You can use wildcards like %GAS, GAS% or %GAS%.

--
Charles Sweeney
<a style='text-decoration: underline;' href="http://CharlesSweeney.com" target="_blank">http://CharlesSweeney.com</a><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: mysql help please? 
Back to top
Login to vote
venomx

External


Since: Jun 13, 2004
Posts: 1064



(Msg. 3) Posted: Tue Mar 22, 2005 6:35 am
Post subject: Re: mysql help please? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Charles Sweeney wrote:
 > Viper wrote
 >
  >> 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....
 >
 > If you go to the main page for your database (top link on the left)
 > you can then hit "search" and enter GAS in the search box.
 >
 > You can select which tables to search. If you select them all, it
 > will search every field on every table.
 >
 > You can use wildcards like %GAS, GAS% or %GAS%.

Thank you! Smile I never noticed that there lol<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: mysql help please? 
Back to top
Login to vote
newsprofile2

External


Since: Sep 17, 2004
Posts: 131



(Msg. 4) Posted: Tue Mar 22, 2005 6:35 am
Post subject: Re: mysql help please? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Viper" <venomx.RemoveThis@gmail.com> wrote in message
news:dnS%d.14747$Ue6.3916@trndny04...
 > Charles Sweeney wrote:
  >> Viper wrote
  >>
   >>> 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....
  >>
  >> If you go to the main page for your database (top link on the left)
  >> you can then hit "search" and enter GAS in the search box.
  >>
  >> You can select which tables to search. If you select them all, it
  >> will search every field on every table.
  >>
  >> You can use wildcards like %GAS, GAS% or %GAS%.
 >
 > Thank you! Smile I never noticed that there lol
 >

In answer to your original SQL question ...

SELECT * FROM phrase WHERE varname LIKE '%GAS%';<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: mysql help please? 
Back to top
Login to vote
user94

External


Since: Sep 14, 2004
Posts: 2384



(Msg. 5) Posted: Tue Mar 22, 2005 6:35 am
Post subject: Re: mysql help please? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Viper wrote

 > Charles Sweeney wrote:
  >> Viper wrote
  >>
   >>> 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....
  >>
  >> If you go to the main page for your database (top link on the left)
  >> you can then hit "search" and enter GAS in the search box.
  >>
  >> You can select which tables to search. If you select them all, it
  >> will search every field on every table.
  >>
  >> You can use wildcards like %GAS, GAS% or %GAS%.
 >
 > Thank you! Smile I never noticed that there lol

That's the beauty of phpmyadmin, you notice new stuff every time you use
it!

--
Charles Sweeney
<a style='text-decoration: underline;' href="http://CharlesSweeney.com" target="_blank">http://CharlesSweeney.com</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: mysql help please? 
Back to top
Login to vote
Display posts from previous:   
   Web Hosting Problem Solving Community! (Home) -> Webmaster All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]