apphp-snippets

Member since 05/20/2012

3 snippets

9557 profile views

0 Comment(s) Posted

their Tags

php ip browser post javascript page http text css table links url mail file path convert extension directory xml download js redirect button window email validation background html html5 code sql error center jquery load data json class line mysql database replace find htaccess image object log CSS3 csv

Profile

Achievement

apphp-snippets's Recent SnippetsTagged sql

All /

« Prev 1 Next »

SQL Calculate Relative Time Ago

Here you may find some useful snippets for calculating relative time for different purposes: to get info from a column within certain date, like the latest 7 days, to get time interval etc.

0 930 posted 10 years ago by apphp-snippets

PL/SQL Search in Tags Set in MySQL

Lets say you have a table with field called "tags" that consists from tags separated by commas and you want to check whether it includes a required tag. Here the simplest ways of doing that.

0 994 posted 11 years ago by apphp-snippets

PL/SQL Selecting a Random Row from Table in MySQL

Here the simplest way of selecting random rows from the MySQL database with using "ORDER BY RAND()" clause in the query.

0 1143 posted 11 years ago by apphp-snippets