Welcome to MobyThreads.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in
All support for the MobyThreads Threaded phpBB MOD can now be found on welsolutions at this forum

mysql help please?

  
   Web Hosting and Web Master Forums (Home) -> Webmaster RSS
Next:  Loosing Active Directory Users and Computers icon..  
Author Message
venomx

External


Since: Jun 13, 2004
Posts: 1016



(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: 1016



(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: 128



(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.DeleteThis@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:   
Related Topics:
Help with MySQL - hi i am building a site from my pc using APACHE/ and all that other stuff need a little help... Now i want to add some php stuff )INSTALLED AND WORKS( , but this needs mySQL )INSTALLED AND WORKS( how would i setup the databases (named: dbase) : before on...

PHP and... XML or MySQL? - A lot of information seems to be out there regarding the use of PHP and MySQL together. I can't find many books about PHP and XML. Is there a reason for this? Or is it just because PHP has only recently supported XML in a thorough way? I guess what..

php/MySQL databases - Hi all, On my website I have a large "recommended sites" section. It's in HTML. I want to change it to a PHP/MySQL database so people can see which links are most popular, which links are new, can easily submit links of their own, etc. What...

mysql errors - Hi, I've run a php script that uses mysql databases without problems on one server, but then I changed web hosts and installed it the same way buy I get a lot of errors which are all derived from the script not being able to interact with the database.....

mysql question - Ok I have a .sql file thats 30MB in my home dir... I need to use SSH to put it in the database because it wont work with doing it via phpmyadmin... Can anyone remind me what the line is again to do this via SSH? Thanks.... -- Viper http://www.zurax.co...
   Web Hosting and Web Master Forums (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 ]