[SOLVED] Conformation and Searches

[LemonInflux]

I have to questions;

 

A) is '%' the mathematical symbol for 'is divisible by' in php? Say, if I put, if(10 % 2){ }, would that mean 'if 10 is divisible by 2, do this'?

 

B) MySQL searches. How are they done? I recall something like "SELECT * FROM `table` WHERE `field` = '%value%'"; is that right?

 

Thanks,

 

Tom.

[pocobueno1388]

As for the query, it would be like this

 

SELECT * FROM table WHERE field LIKE '%value%'

 

I'm not going to comment on your first question as I don't know a ton about it. I believe you are correct though.

[revraz]

A: Can probably find that answer in the Math forum

B: http://www.sqlzoo.net/

[~n[EO]n~]

$a % $b is known as Modulus, result is Remainder of $a divided by $b.

 

[The Little Guy]

in Mysql when doing %

like this:

"SELECT * FROM `table` WHERE `column` LIKE '10%'"

 

- That way makes a % a wild card

 

Here are you modulo options:

"SELECT MOD(234, 10)"

"SELECT 253 % 7"

"SELECT MOD(29,9)"

"SELECT 29 MOD 9"

Found: http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html