free code snippets - Mysql - spyka Webmaster

Add string to field

in mysql

SELECT * FROM `table` WHERE `field` = CONCAT(field2, '_hello')

Allows you to add a string to end or start of a field to use when comparing or selecting data. The second argument is added to the end of the first

Select code

Counting records

in mysql

SELECT COUNT(*) from `table` WHERE `field` = 'value'

This query will return the amount of records for the query

Select code

Selecting the minimum value

in mysql

SELECT MIN(`downloads`) as `downloads` FROM `scripts`

Selecting the minimum value of the field in the brackets.

Select code

Selecting the maximum value

in mysql

SELECT MAX(`downloads`) as `downloads` FROM `scripts`

Selecting the maxmimum value of the column in the brackets.

Select code

Select random record

in mysql

SELECT * FROM `cities` ORDER BY rand() LIMIT 0,1

This SQL snippet will select a random record from a mysql database

Select code

Selecting distinct entries

in mysql

SELECT DISTINCT `city` FROM `people`

This query will show you how to select only distinct (unique) entries from a database.

Select code

Tips & advice

Need coding help? Tips, tricks or advice? Check out our webmaster forums

free css templates

PHP, Javascript, CSS & mySQL code snippets