Wildcard?
Posted: Sat Mar 08, 2008 12:17 am
Hello all,
I'm currently in need for some help, basically I would like to show all information on accounts that starts with the letter A
for example mysql has a table named names which has all sorts of names, some starting with A,B,C,D etc...
I want to be able to get all information on only the user's that start with the letter A
Would I use wildcard (*) to do this? Could you possible give me a brief example?
Also I had another question,
We use Cpanel which has mysql built in, we would like to connect to our mysql from another server, what would we be changing localhost to? would it be the domain:30083 ? (bare in mind we are using cpanel)
Thanks in advance any comments is much appericated!
=)
I'm currently in need for some help, basically I would like to show all information on accounts that starts with the letter A
for example mysql has a table named names which has all sorts of names, some starting with A,B,C,D etc...
I want to be able to get all information on only the user's that start with the letter A
Would I use wildcard (*) to do this? Could you possible give me a brief example?
Also I had another question,
We use Cpanel which has mysql built in, we would like to connect to our mysql from another server, what would we be changing localhost to? would it be the domain:30083 ? (bare in mind we are using cpanel)
Thanks in advance any comments is much appericated!
=)