php - MYSQL select where field does not contain a certain string character -

i use sql select sites urls table.

$sql = 'select * pages "myurl field";

however want little more specific query. there few duplicate links in table example:

about-us ./about-us

i don't want ./about us field selected. there way of saying:

select * "myurl field" not begin . /

or should forget , parse using php?

select * pages some_col not './%';

this fetch rows some_col not starting ./

O9