Topic: Picking out different letters from mysql.

[whelpton]

Hi everyone,

Is there a way of modifying this, or using something similar, that will enable me to select users from the mysql database with the letter 'v'?

Code: [Select]

    <?php
include '/home/alport/public_html/shared/connect.php';
$query = "SELECT * FROM Users ORDER BY Username ASC";
$result = @mysql_query($query);
if ($result){
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
Thanks

[PFMaBiSmAd]

http://w3schools.com/sql/sql_like.asp

[Maq]

Is there a way of modifying this, or using something similar, that will enable me to select users from the mysql database with the letter 'v'?

Do you mean anywhere in their name, or starting with v?

[whelpton]

Is there a way of modifying this, or using something similar, that will enable me to select users from the mysql database with the letter 'v'?

Do you mean anywhere in their name, or starting with v?

Starting With A V

[Maq]

You need to use something like:

Code: [Select]

LIKE 'V%'