How to exlude empty value from selecting mysqli row - Mysqli Select Tutorial

Skip the empty value from mysqli selects query.

Use: name != ''

Database

1. Dhaka

2. London

Here skips 2 number rows which was empty

See the example.

Example: MYSQLI

$sql = "SELECT * FROM data WHERE name != '' ORDER BY id asc LIMIT 10";