simple query

ot;: Something like SELECT * FROM `phrases` WHERE ph="who*"; I tried the manual but cant make sense of it. How can we use wildcards on selects? Thanks Pag -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: finding out what localhost is

LES LIKE 'port'" will tell you what port number it's listening on. Already checked the variables, the skip_network is OFF, and the port is shown. I assume its then possible to remotely connect to the database? BUt how do i know where to connect to? Thats my doubt? By d

finding out what localhost is

quot; of the mysql database on the crappyserver? Thanks. Pag -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Selected items delete

#x27; where num=1 and num=13 and num=34" etc. Thanks a lot. Pag -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

weird comparison problem

l it, it fails, as it should :-) How can i make a correct check with upper case distinction? Thanks Pag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Displaying news across several pages

LIMIT 10". Is there any mysql command to select the next 10 items, for example? something like "LIMIT from 10 to 20" hehe, i know it sounds weird. :-) Thanks. Pag - Before posting, please check: http://www.

ORDER dilemma

our/minute" basically i need some select command like this: SELECT * FROM NEWS ORDER BY "year/month/day - hour/minute" DESC LIMIT 10 How can i do such a thing? Thanks. Pag - Before posting, please chec